Linux: MySQL Survival Guide

Last update: 1/27/2025, 5:01:36 PM

Connect to a MySQL database with the CLI mysql --user= --password

List databases SHOW DATABASES

List users SELECT Host, User FROM mysql.user

Grant privileges

GRANT ALL PRIVILEGES
ON database.*
TO 'user'@'%'
IDENTIFIED BY 'newpassword';

Dump database mysqldump -u<user> -p<password> <database> > dump.sql

Restore database mysql -u<user> -p<password> <database> < dump.sql